﻿CREATE TABLE [dbo].[Goal] (
    [GoalId]            INT      IDENTITY (1, 1) NOT NULL,
    [AccountId]         INT      NOT NULL,
    [CreatedOn]         DATETIME NOT NULL,
    [TargetValue]       FLOAT    NOT NULL,
    [TargetDate]        DATETIME NULL,
    [DecreaseTo]        BIT      NOT NULL,
    [AchievedOn]        DATETIME NULL,
    [Active]            BIT      NOT NULL,
    [MeasurementTypeId] INT      NOT NULL
);

